Skip Headers

SQL*Plus® User's Guide and Reference Release 10.2 Part Number B14357-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# STORE

STORE is not available in iSQL*Plus.

Syntax

STORE SET file_name[.ext] [ CRE[ATE | REP[LACE] | APP[END]]

Saves attributes of the current SQL*Plus environment in a script.

Terms

See SAVE for information on the other terms and clauses in the STORE command syntax.

SET

Saves the values of the system variables.

Usage

This command creates a script which can be executed with the START, @ ("at" sign) or @@ (double "at" sign) commands.

If you want to store a file under a name identical to a STORE command clause (that is, CREATE, REPLACE or APPEND), you must put the name in single quotes or specify a file extension.

Examples

To store the current SQL*Plus system variables in a file named DEFAULTENV with the default command-file extension, enter

    STORE SET DEFAULTENV

To append the current SQL*Plus system variables to an existing file called DEFAULTENV with the extension OLD, enter

    STORE SET DEFAULTENV.OLD APPEND